{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Instructions","Spreadsheet History"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Federal Minimum Wage Calculator"]
[null,null,null,"Version",{"$f":"MAX('Spreadsheet History'!A:A)","v":"2015-05-27"},{"$f":"MAX('Spreadsheet History'!B:B)","v":1}]
[null,"Claim number"]
[null,"Employer name"]
[null,"Worker name"]
[]
[null,"Notional Weekly Earnings"]
[null,"Average pre-injury hours worked per week"]
[null,"FMW weekly rate (if 38+ hours)"]
[null,"FMW hourly rate (if <38 hours)"]
[null,"Federal Minimum Wage safety net",{"$f":"IF(C8>=38,C9,C10*C8)","v":0}]
[]
[null,"Earnings from employment"]
[null,"Redeemed weekly payments (prior redemptions)"]
[null,"% of notional weekly earnings"]
[null,"Calculated top up payment",{"$f":"(C7-C13-C14)*C15","v":0}]
[null,"Combined weekly payment",{"$f":"C16+C13+C14","v":0}]
[]
[null,"New weekly payment / top up amount",{"$f":"IF(C17>=C11,\"no change\",C11-C13-C14)","v":"no change"},null,{"$f":"IF(C17>=C11,C16,\"\")","v":0}]

{"sheet":"Instructions","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,1,5,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,1,10,7],[0,0,0,9],[1,2,1,9],[2,1,2,8],[4,1,4,7]]}
["Federal Minimum Wage Calculator",null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"INSTRUCTIONS"]
[]
[null,"The calculator is useful to confirm the income support to be paid to the worker to ensure they do not drop below the relevant Federal minimum wage (FMW). This calculator will only need to be used for workers impacted by the FMW safety net."]
[null,"Before using the calculator it is necessary to identify the relevant FMW rate. This information should be recorded in the AWE evidence screen under ‘Minimum Wage information’."]
[]
[null,"1. Enter the following details at the top of the sheet:\n   -  Claim number\n   -  Employer name \n   -  Worker name \n   -  Average pre-injury hours worker per week\n   -  FMW weekly or hourly rate"]
[null,"Please note; If the worker’s pre-injury hours were greater than 38, the FMW weekly rate should be entered. If the worker’s pre-injury hours were less than 38, the FMW hourly rate should be entered."]
[null,"2. Enter the following details (if applicable) to calculate the top up payment:\n  - Earnings from employment\n  - Redeemed weekly payments (this is the full 49(2) or 49(3) figure under the RTW Act or the full 35(5) figure under the WRCA)\n  - % of notional weekly earnings"]
[null,"3. If the combined weekly payment is not less than the relevant FMW safety net, no changes are required to the calculated top up payment. If the combined weekly payment is less than the relevant FMW safety net a new weekly payment will be calculated which must be paid to the worker."]

{"sheet":"Spreadsheet History","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Version","Author","Changes"]
["2015-05-27",1,"Steve Hammond","Initial version"]